Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	25000
Missing cells	13779
Missing cells (%)	2.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.6 MiB
Average record size in memory	192.0 B

Variable types

Categorical	12
Numeric	12

Alerts

`Ware_house_ID` has a high cardinality: 25000 distinct values	High cardinality
`WH_Manager_ID` has a high cardinality: 25000 distinct values	High cardinality
`wh_est_year` is highly overall correlated with `storage_issue_reported_l3m` and 1 other fields	High correlation
`storage_issue_reported_l3m` is highly overall correlated with `wh_est_year` and 1 other fields	High correlation
`govt_check_l3m` is highly overall correlated with `WH_capacity_size` and 1 other fields	High correlation
`product_wg_ton` is highly overall correlated with `wh_est_year` and 1 other fields	High correlation
`WH_capacity_size` is highly overall correlated with `govt_check_l3m` and 1 other fields	High correlation
`WH_regional_zone` is highly overall correlated with `govt_check_l3m` and 1 other fields	High correlation
`Location_type` is highly imbalanced (59.2%)	Imbalance
`flood_impacted` is highly imbalanced (53.7%)	Imbalance
`flood_proof` is highly imbalanced (69.4%)	Imbalance
`workers_num` has 990 (4.0%) missing values	Missing
`wh_est_year` has 11881 (47.5%) missing values	Missing
`approved_wh_govt_certificate` has 908 (3.6%) missing values	Missing
`Ware_house_ID` is uniformly distributed	Uniform
`WH_Manager_ID` is uniformly distributed	Uniform
`Ware_house_ID` has unique values	Unique
`WH_Manager_ID` has unique values	Unique
`num_refill_req_l3m` has 2912 (11.6%) zeros	Zeros
`transport_issue_l1y` has 15215 (60.9%) zeros	Zeros
`storage_issue_reported_l3m` has 908 (3.6%) zeros	Zeros
`wh_breakdown_l3m` has 908 (3.6%) zeros	Zeros

Reproduction

Analysis started	2023-03-17 09:16:20.133851
Analysis finished	2023-03-17 09:16:38.909494
Duration	18.78 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Ware_house_ID
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	25000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

WH_100000	1
WH_116650	1
WH_116672	1
WH_116671	1
WH_116670	1
Other values (24995)	24995

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	225000
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25000 ?
Unique (%)	100.0%

Sample

1st row	WH_100000
2nd row	WH_100001
3rd row	WH_100002
4th row	WH_100003
5th row	WH_100004

Common Values

Value	Count	Frequency (%)
WH_100000	1	< 0.1%
WH_116650	1	< 0.1%
WH_116672	1	< 0.1%
WH_116671	1	< 0.1%
WH_116670	1	< 0.1%
WH_116669	1	< 0.1%
WH_116668	1	< 0.1%
WH_116667	1	< 0.1%
WH_116666	1	< 0.1%
WH_116665	1	< 0.1%
Other values (24990)	24990	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wh_100000	1	< 0.1%
wh_100076	1	< 0.1%
wh_100005	1	< 0.1%
wh_100006	1	< 0.1%
wh_100007	1	< 0.1%
wh_100008	1	< 0.1%
wh_100009	1	< 0.1%
wh_100010	1	< 0.1%
wh_100011	1	< 0.1%
wh_100012	1	< 0.1%
Other values (24990)	24990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	45500	20.2%
W	25000	11.1%
H	25000	11.1%
_	25000	11.1%
0	20500	9.1%
2	15500	6.9%
4	10500	4.7%
3	10500	4.7%
6	9500	4.2%
5	9500	4.2%
Other values (3)	28500	12.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	150000	66.7%
Uppercase Letter	50000	22.2%
Connector Punctuation	25000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	45500	30.3%
0	20500	13.7%
2	15500	10.3%
4	10500	7.0%
3	10500	7.0%
6	9500	6.3%
5	9500	6.3%
7	9500	6.3%
9	9500	6.3%
8	9500	6.3%

Uppercase Letter

Value	Count	Frequency (%)
W	25000	50.0%
H	25000	50.0%

Connector Punctuation

Value	Count	Frequency (%)
_	25000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	175000	77.8%
Latin	50000	22.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	45500	26.0%
_	25000	14.3%
0	20500	11.7%
2	15500	8.9%
4	10500	6.0%
3	10500	6.0%
6	9500	5.4%
5	9500	5.4%
7	9500	5.4%
9	9500	5.4%

Latin

Value	Count	Frequency (%)
W	25000	50.0%
H	25000	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	225000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	45500	20.2%
W	25000	11.1%
H	25000	11.1%
_	25000	11.1%
0	20500	9.1%
2	15500	6.9%
4	10500	4.7%
3	10500	4.7%
6	9500	4.2%
5	9500	4.2%
Other values (3)	28500	12.7%

WH_Manager_ID
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	25000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

EID_50000	1
EID_66650	1
EID_66672	1
EID_66671	1
EID_66670	1
Other values (24995)	24995

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	225000
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25000 ?
Unique (%)	100.0%

Sample

1st row	EID_50000
2nd row	EID_50001
3rd row	EID_50002
4th row	EID_50003
5th row	EID_50004

Common Values

Value	Count	Frequency (%)
EID_50000	1	< 0.1%
EID_66650	1	< 0.1%
EID_66672	1	< 0.1%
EID_66671	1	< 0.1%
EID_66670	1	< 0.1%
EID_66669	1	< 0.1%
EID_66668	1	< 0.1%
EID_66667	1	< 0.1%
EID_66666	1	< 0.1%
EID_66665	1	< 0.1%
Other values (24990)	24990	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
eid_50000	1	< 0.1%
eid_50076	1	< 0.1%
eid_50005	1	< 0.1%
eid_50006	1	< 0.1%
eid_50007	1	< 0.1%
eid_50008	1	< 0.1%
eid_50009	1	< 0.1%
eid_50010	1	< 0.1%
eid_50011	1	< 0.1%
eid_50012	1	< 0.1%
Other values (24990)	24990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
E	25000	11.1%
I	25000	11.1%
D	25000	11.1%
_	25000	11.1%
5	19500	8.7%
6	19500	8.7%
7	14500	6.4%
0	10500	4.7%
2	10500	4.7%
1	10500	4.7%
Other values (4)	40000	17.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	125000	55.6%
Uppercase Letter	75000	33.3%
Connector Punctuation	25000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	19500	15.6%
6	19500	15.6%
7	14500	11.6%
0	10500	8.4%
2	10500	8.4%
1	10500	8.4%
4	10500	8.4%
3	10500	8.4%
9	9500	7.6%
8	9500	7.6%

Uppercase Letter

Value	Count	Frequency (%)
E	25000	33.3%
I	25000	33.3%
D	25000	33.3%

Connector Punctuation

Value	Count	Frequency (%)
_	25000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	150000	66.7%
Latin	75000	33.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
_	25000	16.7%
5	19500	13.0%
6	19500	13.0%
7	14500	9.7%
0	10500	7.0%
2	10500	7.0%
1	10500	7.0%
4	10500	7.0%
3	10500	7.0%
9	9500	6.3%

Latin

Value	Count	Frequency (%)
E	25000	33.3%
I	25000	33.3%
D	25000	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	225000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	25000	11.1%
I	25000	11.1%
D	25000	11.1%
_	25000	11.1%
5	19500	8.7%
6	19500	8.7%
7	14500	6.4%
0	10500	4.7%
2	10500	4.7%
1	10500	4.7%
Other values (4)	40000	17.8%

Location_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

Rural	22957
Urban	2043

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	125000
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Urban
2nd row	Rural
3rd row	Rural
4th row	Rural
5th row	Rural

Common Values

Value	Count	Frequency (%)
Rural	22957	91.8%
Urban	2043	8.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rural	22957	91.8%
urban	2043	8.2%

Most occurring characters

Value	Count	Frequency (%)
r	25000	20.0%
a	25000	20.0%
R	22957	18.4%
u	22957	18.4%
l	22957	18.4%
U	2043	1.6%
b	2043	1.6%
n	2043	1.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	100000	80.0%
Uppercase Letter	25000	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	25000	25.0%
a	25000	25.0%
u	22957	23.0%
l	22957	23.0%
b	2043	2.0%
n	2043	2.0%

Uppercase Letter

Value	Count	Frequency (%)
R	22957	91.8%
U	2043	8.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	125000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	25000	20.0%
a	25000	20.0%
R	22957	18.4%
u	22957	18.4%
l	22957	18.4%
U	2043	1.6%
b	2043	1.6%
n	2043	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	125000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	25000	20.0%
a	25000	20.0%
R	22957	18.4%
u	22957	18.4%
l	22957	18.4%
U	2043	1.6%
b	2043	1.6%
n	2043	1.6%

WH_capacity_size
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

Large	10169
Mid	10020
Small	4811

Length

Max length	5
Median length	5
Mean length	4.1984
Min length	3

Characters and Unicode

Total characters	104960
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Small
2nd row	Large
3rd row	Mid
4th row	Mid
5th row	Large

Common Values

Value	Count	Frequency (%)
Large	10169	40.7%
Mid	10020	40.1%
Small	4811	19.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
large	10169	40.7%
mid	10020	40.1%
small	4811	19.2%

Most occurring characters

Value	Count	Frequency (%)
a	14980	14.3%
L	10169	9.7%
r	10169	9.7%
g	10169	9.7%
e	10169	9.7%
M	10020	9.5%
i	10020	9.5%
d	10020	9.5%
l	9622	9.2%
S	4811	4.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79960	76.2%
Uppercase Letter	25000	23.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14980	18.7%
r	10169	12.7%
g	10169	12.7%
e	10169	12.7%
i	10020	12.5%
d	10020	12.5%
l	9622	12.0%
m	4811	6.0%

Uppercase Letter

Value	Count	Frequency (%)
L	10169	40.7%
M	10020	40.1%
S	4811	19.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	104960	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14980	14.3%
L	10169	9.7%
r	10169	9.7%
g	10169	9.7%
e	10169	9.7%
M	10020	9.5%
i	10020	9.5%
d	10020	9.5%
l	9622	9.2%
S	4811	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	104960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14980	14.3%
L	10169	9.7%
r	10169	9.7%
g	10169	9.7%
e	10169	9.7%
M	10020	9.5%
i	10020	9.5%
d	10020	9.5%
l	9622	9.2%
S	4811	4.6%

zone
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

North	10278
West	7931
South	6362
East	429

Length

Max length	5
Median length	5
Mean length	4.6656
Min length	4

Characters and Unicode

Total characters	116640
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	West
2nd row	North
3rd row	South
4th row	North
5th row	North

Common Values

Value	Count	Frequency (%)
North	10278	41.1%
West	7931	31.7%
South	6362	25.4%
East	429	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
north	10278	41.1%
west	7931	31.7%
south	6362	25.4%
east	429	1.7%

Most occurring characters

Value	Count	Frequency (%)
t	25000	21.4%
o	16640	14.3%
h	16640	14.3%
N	10278	8.8%
r	10278	8.8%
s	8360	7.2%
W	7931	6.8%
e	7931	6.8%
S	6362	5.5%
u	6362	5.5%
Other values (2)	858	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91640	78.6%
Uppercase Letter	25000	21.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	25000	27.3%
o	16640	18.2%
h	16640	18.2%
r	10278	11.2%
s	8360	9.1%
e	7931	8.7%
u	6362	6.9%
a	429	0.5%

Uppercase Letter

Value	Count	Frequency (%)
N	10278	41.1%
W	7931	31.7%
S	6362	25.4%
E	429	1.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	116640	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	25000	21.4%
o	16640	14.3%
h	16640	14.3%
N	10278	8.8%
r	10278	8.8%
s	8360	7.2%
W	7931	6.8%
e	7931	6.8%
S	6362	5.5%
u	6362	5.5%
Other values (2)	858	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	116640	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	25000	21.4%
o	16640	14.3%
h	16640	14.3%
N	10278	8.8%
r	10278	8.8%
s	8360	7.2%
W	7931	6.8%
e	7931	6.8%
S	6362	5.5%
u	6362	5.5%
Other values (2)	858	0.7%

WH_regional_zone
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

Zone 6	8339
Zone 5	4587
Zone 4	4176
Zone 2	2963
Zone 3	2881

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	150000
Distinct characters	11
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Zone 6
2nd row	Zone 5
3rd row	Zone 2
4th row	Zone 3
5th row	Zone 5

Common Values

Value	Count	Frequency (%)
Zone 6	8339	33.4%
Zone 5	4587	18.3%
Zone 4	4176	16.7%
Zone 2	2963	11.9%
Zone 3	2881	11.5%
Zone 1	2054	8.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
zone	25000	50.0%
6	8339	16.7%
5	4587	9.2%
4	4176	8.4%
2	2963	5.9%
3	2881	5.8%
1	2054	4.1%

Most occurring characters

Value	Count	Frequency (%)
Z	25000	16.7%
o	25000	16.7%
n	25000	16.7%
e	25000	16.7%
	25000	16.7%
6	8339	5.6%
5	4587	3.1%
4	4176	2.8%
2	2963	2.0%
3	2881	1.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	75000	50.0%
Uppercase Letter	25000	16.7%
Space Separator	25000	16.7%
Decimal Number	25000	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	8339	33.4%
5	4587	18.3%
4	4176	16.7%
2	2963	11.9%
3	2881	11.5%
1	2054	8.2%

Lowercase Letter

Value	Count	Frequency (%)
o	25000	33.3%
n	25000	33.3%
e	25000	33.3%

Uppercase Letter

Value	Count	Frequency (%)
Z	25000	100.0%

Space Separator

Value	Count	Frequency (%)
	25000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	100000	66.7%
Common	50000	33.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
	25000	50.0%
6	8339	16.7%
5	4587	9.2%
4	4176	8.4%
2	2963	5.9%
3	2881	5.8%
1	2054	4.1%

Latin

Value	Count	Frequency (%)
Z	25000	25.0%
o	25000	25.0%
n	25000	25.0%
e	25000	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	150000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
Z	25000	16.7%
o	25000	16.7%
n	25000	16.7%
e	25000	16.7%
	25000	16.7%
6	8339	5.6%
5	4587	3.1%
4	4176	2.8%
2	2963	2.0%
3	2881	1.9%

num_refill_req_l3m
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.08904

Minimum	0
Maximum	8
Zeros	2912
Zeros (%)	11.6%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	6
95-th percentile	8
Maximum	8
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.6066115
Coefficient of variation (CV)	0.63746296
Kurtosis	-1.2206972
Mean	4.08904
Median Absolute Deviation (MAD)	2
Skewness	-0.075216703
Sum	102226
Variance	6.7944237
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	2990	12.0%
8	2970	11.9%
5	2941	11.8%
0	2912	11.6%
7	2873	11.5%
1	2856	11.4%
4	2846	11.4%
6	2804	11.2%
2	1808	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2912	11.6%
1	2856	11.4%
2	1808	7.2%
3	2990	12.0%
4	2846	11.4%
5	2941	11.8%
6	2804	11.2%
7	2873	11.5%
8	2970	11.9%

Value	Count	Frequency (%)
8	2970	11.9%
7	2873	11.5%
6	2804	11.2%
5	2941	11.8%
4	2846	11.4%
3	2990	12.0%
2	1808	7.2%
1	2856	11.4%
0	2912	11.6%

transport_issue_l1y
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.77368

Minimum	0
Maximum	5
Zeros	15215
Zeros (%)	60.9%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1994485
Coefficient of variation (CV)	1.5503161
Kurtosis	1.8384391
Mean	0.77368
Median Absolute Deviation (MAD)	0
Skewness	1.6109066
Sum	19342
Variance	1.4386768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	15215	60.9%
1	4644	18.6%
2	2198	8.8%
3	1818	7.3%
4	777	3.1%
5	348	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15215	60.9%
1	4644	18.6%
2	2198	8.8%
3	1818	7.3%
4	777	3.1%
5	348	1.4%

Value	Count	Frequency (%)
5	348	1.4%
4	777	3.1%
3	1818	7.3%
2	2198	8.8%
1	4644	18.6%
0	15215	60.9%

Competitor_in_mkt
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1042

Minimum	0
Maximum	12
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	5
Maximum	12
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.141663
Coefficient of variation (CV)	0.36778012
Kurtosis	1.7863684
Mean	3.1042
Median Absolute Deviation (MAD)	1
Skewness	0.97845565
Sum	77605
Variance	1.3033945
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	8669	34.7%
3	7094	28.4%
4	6708	26.8%
5	1265	5.1%
6	546	2.2%
1	432	1.7%
7	189	0.8%
8	76	0.3%
9	13	0.1%
10	6	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	432	1.7%
2	8669	34.7%
3	7094	28.4%
4	6708	26.8%
5	1265	5.1%
6	546	2.2%
7	189	0.8%
8	76	0.3%
9	13	0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
10	6	< 0.1%
9	13	0.1%
8	76	0.3%
7	189	0.8%
6	546	2.2%
5	1265	5.1%
4	6708	26.8%
3	7094	28.4%
2	8669	34.7%

retail_shop_num
Real number (ℝ)

Distinct	4906
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4985.7116

Minimum	1821
Maximum	11008
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	1821
5-th percentile	3513
Q1	4313
median	4859
Q3	5500
95-th percentile	6934.1
Maximum	11008
Range	9187
Interquartile range (IQR)	1187

Descriptive statistics

Standard deviation	1052.8253
Coefficient of variation (CV)	0.2111685
Kurtosis	1.851946
Mean	4985.7116
Median Absolute Deviation (MAD)	587
Skewness	0.90830174
Sum	1.2464279 × 10⁸
Variance	1108441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4860	22	0.1%
4808	22	0.1%
4367	21	0.1%
4816	21	0.1%
4659	21	0.1%
4611	21	0.1%
5022	21	0.1%
4918	20	0.1%
4783	20	0.1%
4850	20	0.1%
Other values (4896)	24791	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1821	1	< 0.1%
1871	1	< 0.1%
1905	1	< 0.1%
1915	1	< 0.1%
1953	1	< 0.1%
1959	1	< 0.1%
1971	1	< 0.1%
1980	1	< 0.1%
1999	1	< 0.1%
2008	1	< 0.1%

Value	Count	Frequency (%)
11008	1	< 0.1%
10846	1	< 0.1%
10562	1	< 0.1%
10320	1	< 0.1%
10224	1	< 0.1%
10169	1	< 0.1%
10156	1	< 0.1%
10151	1	< 0.1%
10150	1	< 0.1%
10041	1	< 0.1%

wh_owner_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

Company Owned	13578
Rented	11422

Length

Max length	13
Median length	13
Mean length	9.80184
Min length	6

Characters and Unicode

Total characters	245046
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rented
2nd row	Company Owned
3rd row	Company Owned
4th row	Rented
5th row	Company Owned

Common Values

Value	Count	Frequency (%)
Company Owned	13578	54.3%
Rented	11422	45.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
company	13578	35.2%
owned	13578	35.2%
rented	11422	29.6%

Most occurring characters

Value	Count	Frequency (%)
n	38578	15.7%
e	36422	14.9%
d	25000	10.2%
C	13578	5.5%
o	13578	5.5%
m	13578	5.5%
p	13578	5.5%
a	13578	5.5%
y	13578	5.5%
	13578	5.5%
Other values (4)	50000	20.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	192890	78.7%
Uppercase Letter	38578	15.7%
Space Separator	13578	5.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	38578	20.0%
e	36422	18.9%
d	25000	13.0%
o	13578	7.0%
m	13578	7.0%
p	13578	7.0%
a	13578	7.0%
y	13578	7.0%
w	13578	7.0%
t	11422	5.9%

Uppercase Letter

Value	Count	Frequency (%)
C	13578	35.2%
O	13578	35.2%
R	11422	29.6%

Space Separator

Value	Count	Frequency (%)
	13578	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	231468	94.5%
Common	13578	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	38578	16.7%
e	36422	15.7%
d	25000	10.8%
C	13578	5.9%
o	13578	5.9%
m	13578	5.9%
p	13578	5.9%
a	13578	5.9%
y	13578	5.9%
O	13578	5.9%
Other values (3)	36422	15.7%

Common

Value	Count	Frequency (%)
	13578	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	245046	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	38578	15.7%
e	36422	14.9%
d	25000	10.2%
C	13578	5.5%
o	13578	5.5%
m	13578	5.5%
p	13578	5.5%
a	13578	5.5%
y	13578	5.5%
	13578	5.5%
Other values (4)	50000	20.4%

distributor_num
Real number (ℝ)

Distinct	56
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.41812

Minimum	15
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	15
5-th percentile	17
Q1	29
median	42
Q3	56
95-th percentile	68
Maximum	70
Range	55
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	16.064329
Coefficient of variation (CV)	0.37871383
Kurtosis	-1.1875636
Mean	42.41812
Median Absolute Deviation (MAD)	14
Skewness	0.015212662
Sum	1060453
Variance	258.06266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31	490	2.0%
41	481	1.9%
69	481	1.9%
37	479	1.9%
29	479	1.9%
21	478	1.9%
40	477	1.9%
28	474	1.9%
47	469	1.9%
33	467	1.9%
Other values (46)	20225	80.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15	436	1.7%
16	431	1.7%
17	415	1.7%
18	439	1.8%
19	416	1.7%
20	440	1.8%
21	478	1.9%
22	460	1.8%
23	450	1.8%
24	454	1.8%

Value	Count	Frequency (%)
70	438	1.8%
69	481	1.9%
68	400	1.6%
67	422	1.7%
66	421	1.7%
65	453	1.8%
64	452	1.8%
63	459	1.8%
62	447	1.8%
61	444	1.8%

flood_impacted
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

0	22546
1	2454

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	25000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

Most occurring characters

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	25000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	22546	90.2%
1	2454	9.8%

flood_proof
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

0	23634
1	1366

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	25000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

Most occurring characters

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	25000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	23634	94.5%
1	1366	5.5%

electric_supply
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

1	16422
0	8578

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	25000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

Most occurring characters

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	25000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	16422	65.7%
0	8578	34.3%

dist_from_hub
Real number (ℝ)

Distinct	217
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	163.53732

Minimum	55
Maximum	271
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	55
5-th percentile	65
Q1	109
median	164
Q3	218
95-th percentile	261
Maximum	271
Range	216
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	62.718609
Coefficient of variation (CV)	0.38351252
Kurtosis	-1.2006823
Mean	163.53732
Median Absolute Deviation (MAD)	54
Skewness	-0.005998691
Sum	4088433
Variance	3933.624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
239	144	0.6%
84	142	0.6%
209	140	0.6%
258	140	0.6%
204	140	0.6%
242	138	0.6%
145	138	0.6%
256	137	0.5%
186	136	0.5%
108	135	0.5%
Other values (207)	23610	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
55	104	0.4%
56	111	0.4%
57	126	0.5%
58	122	0.5%
59	113	0.5%
60	107	0.4%
61	112	0.4%
62	118	0.5%
63	128	0.5%
64	100	0.4%

Value	Count	Frequency (%)
271	130	0.5%
270	129	0.5%
269	125	0.5%
268	121	0.5%
267	123	0.5%
266	103	0.4%
265	116	0.5%
264	103	0.4%
263	103	0.4%
262	107	0.4%

workers_num
Real number (ℝ)

Distinct	60
Distinct (%)	0.2%
Missing	990
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.944398

Minimum	10
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	10
5-th percentile	18
Q1	24
median	28
Q3	33
95-th percentile	43
Maximum	98
Range	88
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.872534
Coefficient of variation (CV)	0.27198817
Kurtosis	3.4093352
Mean	28.944398
Median Absolute Deviation (MAD)	5
Skewness	1.0599106
Sum	694955
Variance	61.976791
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	1491	6.0%
27	1447	5.8%
29	1402	5.6%
26	1290	5.2%
25	1268	5.1%
24	1228	4.9%
30	1202	4.8%
31	1132	4.5%
23	1077	4.3%
32	1077	4.3%
Other values (50)	11396	45.6%
(Missing)	990	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	5	< 0.1%
11	5	< 0.1%
12	15	0.1%
13	24	0.1%
14	104	0.4%
15	155	0.6%
16	328	1.3%
17	445	1.8%
18	559	2.2%
19	590	2.4%

Value	Count	Frequency (%)
98	5	< 0.1%
92	5	< 0.1%
78	5	< 0.1%
72	5	< 0.1%
67	5	< 0.1%
65	5	< 0.1%
64	5	< 0.1%
63	5	< 0.1%
62	5	< 0.1%
61	14	0.1%

wh_est_year
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	28
Distinct (%)	0.2%
Missing	11881
Missing (%)	47.5%
Infinite	0
Infinite (%)	0.0%
Mean	2009.3832

Minimum	1996
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	1996
5-th percentile	1998
Q1	2003
median	2009
Q3	2016
95-th percentile	2021
Maximum	2023
Range	27
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	7.5282298
Coefficient of variation (CV)	0.0037465377
Kurtosis	-1.175888
Mean	2009.3832
Median Absolute Deviation (MAD)	7
Skewness	0.012416975
Sum	26361098
Variance	56.674244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
2000	551	2.2%
2006	541	2.2%
2002	533	2.1%
2014	531	2.1%
2007	528	2.1%
2001	518	2.1%
2004	515	2.1%
2008	509	2.0%
2016	507	2.0%
1998	507	2.0%
Other values (18)	7879	31.5%
(Missing)	11881	47.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1996	191	0.8%
1997	329	1.3%
1998	507	2.0%
1999	482	1.9%
2000	551	2.2%
2001	518	2.1%
2002	533	2.1%
2003	469	1.9%
2004	515	2.1%
2005	489	2.0%

Value	Count	Frequency (%)
2023	142	0.6%
2022	332	1.3%
2021	485	1.9%
2020	496	2.0%
2019	507	2.0%
2018	498	2.0%
2017	488	2.0%
2016	507	2.0%
2015	502	2.0%
2014	531	2.1%

storage_issue_reported_l3m
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	37
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.13044

Minimum	0
Maximum	39
Zeros	908
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	10
median	18
Q3	24
95-th percentile	33
Maximum	39
Range	39
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	9.1611081
Coefficient of variation (CV)	0.53478534
Kurtosis	-0.6801423
Mean	17.13044
Median Absolute Deviation (MAD)	7
Skewness	0.11334521
Sum	428261
Variance	83.925902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
24	1424	5.7%
5	1351	5.4%
25	1262	5.0%
4	1081	4.3%
18	1070	4.3%
20	1065	4.3%
6	1056	4.2%
19	1022	4.1%
16	938	3.8%
23	917	3.7%
Other values (27)	13814	55.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	908	3.6%
4	1081	4.3%
5	1351	5.4%
6	1056	4.2%
7	491	2.0%
8	406	1.6%
9	787	3.1%
10	637	2.5%
11	867	3.5%
12	739	3.0%

Value	Count	Frequency (%)
39	156	0.6%
38	181	0.7%
37	141	0.6%
36	161	0.6%
35	181	0.7%
34	288	1.2%
33	295	1.2%
32	296	1.2%
31	289	1.2%
30	337	1.3%

temp_reg_mach
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	195.4 KiB

0	17418
1	7582

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	25000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

Most occurring characters

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	25000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	17418	69.7%
1	7582	30.3%

approved_wh_govt_certificate
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	908
Missing (%)	3.6%
Memory size	195.4 KiB

C	5501
B+	4917
B	4812
A	4671
A+	4191

Length

Max length	2
Median length	1
Mean length	1.3780508
Min length	1

Characters and Unicode

Total characters	33200
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A+
5th row	C

Common Values

Value	Count	Frequency (%)
C	5501	22.0%
B+	4917	19.7%
B	4812	19.2%
A	4671	18.7%
A+	4191	16.8%
(Missing)	908	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	9729	40.4%
a	8862	36.8%
c	5501	22.8%

Most occurring characters

Value	Count	Frequency (%)
B	9729	29.3%
+	9108	27.4%
A	8862	26.7%
C	5501	16.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	24092	72.6%
Math Symbol	9108	27.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	9729	40.4%
A	8862	36.8%
C	5501	22.8%

Math Symbol

Value	Count	Frequency (%)
+	9108	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24092	72.6%
Common	9108	27.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	9729	40.4%
A	8862	36.8%
C	5501	22.8%

Common

Value	Count	Frequency (%)
+	9108	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33200	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	9729	29.3%
+	9108	27.4%
A	8862	26.7%
C	5501	16.6%

wh_breakdown_l3m
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.48204

Minimum	0
Maximum	6
Zeros	908
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6903348
Coefficient of variation (CV)	0.48544382
Kurtosis	-0.95214878
Mean	3.48204
Median Absolute Deviation (MAD)	1
Skewness	-0.06802568
Sum	87051
Variance	2.8572317
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	5076	20.3%
3	5006	20.0%
4	4037	16.1%
6	4012	16.0%
5	3925	15.7%
1	2036	8.1%
0	908	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	908	3.6%
1	2036	8.1%
2	5076	20.3%
3	5006	20.0%
4	4037	16.1%
5	3925	15.7%
6	4012	16.0%

Value	Count	Frequency (%)
6	4012	16.0%
5	3925	15.7%
4	4037	16.1%
3	5006	20.0%
2	5076	20.3%
1	2036	8.1%
0	908	3.6%

govt_check_l3m
Real number (ℝ)

Distinct	32
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.81228

Minimum	1
Maximum	32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	21
Q3	26
95-th percentile	31
Maximum	32
Range	31
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6323822
Coefficient of variation (CV)	0.45886953
Kurtosis	-1.0573419
Mean	18.81228
Median Absolute Deviation (MAD)	7
Skewness	-0.36326153
Sum	470307
Variance	74.518022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
26	2908	11.6%
23	1828	7.3%
19	1604	6.4%
28	1465	5.9%
14	1429	5.7%
27	1277	5.1%
6	1224	4.9%
11	1160	4.6%
12	947	3.8%
32	940	3.8%
Other values (22)	10218	40.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	550	2.2%
2	431	1.7%
3	438	1.8%
4	99	0.4%
5	250	1.0%
6	1224	4.9%
7	65	0.3%
8	276	1.1%
9	932	3.7%
10	899	3.6%

Value	Count	Frequency (%)
32	940	3.8%
31	362	1.4%
30	404	1.6%
29	901	3.6%
28	1465	5.9%
27	1277	5.1%
26	2908	11.6%
25	884	3.5%
24	628	2.5%
23	1828	7.3%

product_wg_ton
Real number (ℝ)

Distinct	4561
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22102.633

Minimum	2065
Maximum	55151
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	195.4 KiB

Quantile statistics

Minimum	2065
5-th percentile	5128
Q1	13059
median	22101
Q3	30103
95-th percentile	43113
Maximum	55151
Range	53086
Interquartile range (IQR)	17044

Descriptive statistics

Standard deviation	11607.755
Coefficient of variation (CV)	0.52517522
Kurtosis	-0.5020222
Mean	22102.633
Median Absolute Deviation (MAD)	8959
Skewness	0.33163104
Sum	5.5256582 × 10⁸
Variance	1.3473998 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6081	21	0.1%
5146	21	0.1%
6057	21	0.1%
6104	20	0.1%
6099	20	0.1%
6083	20	0.1%
6107	19	0.1%
6066	19	0.1%
31126	19	0.1%
6097	19	0.1%
Other values (4551)	24801	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2065	1	< 0.1%
2083	1	< 0.1%
2093	1	< 0.1%
2103	1	< 0.1%
2104	1	< 0.1%
2106	1	< 0.1%
2109	1	< 0.1%
2118	1	< 0.1%
2122	1	< 0.1%
2133	1	< 0.1%

Value	Count	Frequency (%)
55151	1	< 0.1%
55150	1	< 0.1%
55144	1	< 0.1%
55132	1	< 0.1%
55120	1	< 0.1%
55115	1	< 0.1%
55112	1	< 0.1%
55111	1	< 0.1%
55095	1	< 0.1%
55093	1	< 0.1%

Auto

Heatmap
Table

	num_refill_req_l3m	transport_issue_l1y	Competitor_in_mkt	retail_shop_num	distributor_num	dist_from_hub	workers_num	wh_est_year	storage_issue_reported_l3m	wh_breakdown_l3m	govt_check_l3m	product_wg_ton	Location_type	WH_capacity_size	zone	WH_regional_zone	wh_owner_type	flood_impacted	flood_proof	electric_supply	temp_reg_mach	approved_wh_govt_certificate
num_refill_req_l3m	1.000	0.016	0.001	-0.002	0.004	-0.000	-0.014	0.016	-0.006	-0.000	-0.003	0.003	0.021	0.008	0.008	0.008	0.000	0.012	0.000	0.018	0.317	0.000
transport_issue_l1y	0.016	1.000	-0.001	-0.003	0.005	0.014	-0.007	-0.014	-0.143	0.017	0.008	-0.169	0.006	0.011	0.006	0.000	0.000	0.000	0.000	0.005	0.026	0.011
Competitor_in_mkt	0.001	-0.001	1.000	-0.180	0.000	0.009	-0.001	-0.013	0.010	0.011	-0.056	0.010	0.000	0.034	0.308	0.049	0.000	0.000	0.000	0.000	0.014	0.000
retail_shop_num	-0.002	-0.003	-0.180	1.000	-0.000	-0.002	-0.001	0.007	-0.007	-0.011	0.065	-0.008	0.007	0.059	0.051	0.045	0.000	0.000	0.000	0.000	0.000	0.004
distributor_num	0.004	0.005	0.000	-0.000	1.000	-0.012	-0.012	-0.012	0.004	0.005	-0.007	0.005	0.000	0.003	0.014	0.000	0.000	0.005	0.017	0.009	0.018	0.000
dist_from_hub	-0.000	0.014	0.009	-0.002	-0.012	1.000	-0.021	0.009	-0.005	-0.000	-0.001	-0.005	0.000	0.000	0.000	0.000	0.000	0.018	0.000	0.000	0.000	0.007
workers_num	-0.014	-0.007	-0.001	-0.001	-0.012	-0.021	1.000	0.005	-0.010	-0.014	-0.006	-0.010	0.000	0.000	0.000	0.006	0.246	0.171	0.098	0.400	0.011	0.000
wh_est_year	0.016	-0.014	-0.013	0.007	-0.012	0.009	0.005	1.000	-0.872	-0.380	0.007	-0.850	0.100	0.016	0.015	0.013	0.000	0.000	0.000	0.022	0.105	0.109
storage_issue_reported_l3m	-0.006	-0.143	0.010	-0.007	0.004	-0.005	-0.010	-0.872	1.000	0.350	-0.009	0.989	0.093	0.011	0.010	0.008	0.000	0.000	0.005	0.017	0.130	0.096
wh_breakdown_l3m	-0.000	0.017	0.011	-0.011	0.005	-0.000	-0.014	-0.380	0.350	1.000	-0.015	0.339	0.065	0.000	0.008	0.000	0.010	0.000	0.014	0.000	0.123	0.049
govt_check_l3m	-0.003	0.008	-0.056	0.065	-0.007	-0.001	-0.006	0.007	-0.009	-0.015	1.000	-0.009	0.010	0.649	0.284	0.567	0.010	0.000	0.005	0.010	0.000	0.000
product_wg_ton	0.003	-0.169	0.010	-0.008	0.005	-0.005	-0.010	-0.850	0.989	0.339	-0.009	1.000	0.085	0.014	0.000	0.004	0.000	0.000	0.000	0.013	0.119	0.127
Location_type	0.021	0.006	0.000	0.007	0.000	0.000	0.000	0.100	0.093	0.065	0.010	0.085	1.000	0.011	0.009	0.010	0.000	0.000	0.000	0.000	0.021	0.016
WH_capacity_size	0.008	0.011	0.034	0.059	0.003	0.000	0.000	0.016	0.011	0.000	0.649	0.014	0.011	1.000	0.174	0.847	0.000	0.000	0.000	0.008	0.000	0.000
zone	0.008	0.006	0.308	0.051	0.014	0.000	0.000	0.015	0.010	0.008	0.284	0.000	0.009	0.174	1.000	0.178	0.000	0.011	0.000	0.000	0.000	0.000
WH_regional_zone	0.008	0.000	0.049	0.045	0.000	0.000	0.006	0.013	0.008	0.000	0.567	0.004	0.010	0.847	0.178	1.000	0.000	0.008	0.006	0.011	0.012	0.003
wh_owner_type	0.000	0.000	0.000	0.000	0.000	0.000	0.246	0.000	0.000	0.010	0.010	0.000	0.000	0.000	0.000	0.000	1.000	0.108	0.029	0.230	0.000	0.000
flood_impacted	0.012	0.000	0.000	0.000	0.005	0.018	0.171	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.011	0.008	0.108	1.000	0.107	0.165	0.006	0.000
flood_proof	0.000	0.000	0.000	0.000	0.017	0.000	0.098	0.000	0.005	0.014	0.005	0.000	0.000	0.000	0.000	0.006	0.029	0.107	1.000	0.114	0.000	0.008
electric_supply	0.018	0.005	0.000	0.000	0.009	0.000	0.400	0.022	0.017	0.000	0.010	0.013	0.000	0.008	0.000	0.011	0.230	0.165	0.114	1.000	0.004	0.000
temp_reg_mach	0.317	0.026	0.014	0.000	0.018	0.000	0.011	0.105	0.130	0.123	0.000	0.119	0.021	0.000	0.000	0.012	0.000	0.006	0.000	0.004	1.000	0.445
approved_wh_govt_certificate	0.000	0.011	0.000	0.004	0.000	0.007	0.000	0.109	0.096	0.049	0.000	0.127	0.016	0.000	0.000	0.003	0.000	0.000	0.008	0.000	0.445	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Ware_house_ID	WH_Manager_ID	Location_type	WH_capacity_size	zone	WH_regional_zone	num_refill_req_l3m	transport_issue_l1y	Competitor_in_mkt	retail_shop_num	wh_owner_type	distributor_num	flood_impacted	flood_proof	electric_supply	dist_from_hub	workers_num	wh_est_year	storage_issue_reported_l3m	temp_reg_mach	approved_wh_govt_certificate	wh_breakdown_l3m	govt_check_l3m	product_wg_ton
0	WH_100000	EID_50000	Urban	Small	West	Zone 6	3	1	2	4651	Rented	24	0	1	1	91	29.0	NaN	13	0	A	5	15	17115
1	WH_100001	EID_50001	Rural	Large	North	Zone 5	0	0	4	6217	Company Owned	47	0	0	1	210	31.0	NaN	4	0	A	3	17	5074
2	WH_100002	EID_50002	Rural	Mid	South	Zone 2	1	0	4	4306	Company Owned	64	0	0	0	161	37.0	NaN	17	0	A	6	22	23137
3	WH_100003	EID_50003	Rural	Mid	North	Zone 3	7	4	2	6000	Rented	50	0	0	0	103	21.0	NaN	17	1	A+	3	27	22115
4	WH_100004	EID_50004	Rural	Large	North	Zone 5	3	1	2	4740	Company Owned	42	1	0	1	112	25.0	2009.0	18	0	C	6	24	24071
5	WH_100005	EID_50005	Rural	Small	West	Zone 1	8	0	2	5053	Rented	37	0	0	1	152	35.0	2009.0	23	1	A+	3	3	32134
6	WH_100006	EID_50006	Rural	Large	West	Zone 6	8	0	4	4449	Company Owned	38	0	0	1	77	27.0	2010.0	24	0	B	3	6	30142
7	WH_100007	EID_50007	Rural	Large	North	Zone 5	1	0	4	7183	Rented	45	0	0	0	241	23.0	NaN	18	0	C	6	24	24093
8	WH_100008	EID_50008	Rural	Small	South	Zone 6	8	1	4	5381	Rented	42	0	0	1	124	22.0	2013.0	13	1	A+	5	2	18082
9	WH_100009	EID_50009	Rural	Small	South	Zone 6	4	3	3	3869	Company Owned	35	0	0	0	78	43.0	NaN	6	0	C	6	2	7130

	Ware_house_ID	WH_Manager_ID	Location_type	WH_capacity_size	zone	WH_regional_zone	num_refill_req_l3m	transport_issue_l1y	Competitor_in_mkt	retail_shop_num	wh_owner_type	distributor_num	flood_impacted	flood_proof	electric_supply	dist_from_hub	workers_num	wh_est_year	storage_issue_reported_l3m	temp_reg_mach	approved_wh_govt_certificate	wh_breakdown_l3m	govt_check_l3m	product_wg_ton
24990	WH_124990	EID_74990	Rural	Small	South	Zone 1	3	0	3	4124	Rented	19	0	0	0	98	27.0	NaN	26	1	A+	3	21	34098
24991	WH_124991	EID_74991	Rural	Mid	West	Zone 4	4	0	4	3672	Rented	58	0	1	0	183	26.0	2006.0	28	1	C	6	26	37065
24992	WH_124992	EID_74992	Rural	Large	West	Zone 5	3	0	2	4312	Company Owned	16	0	0	0	190	20.0	2007.0	17	0	A	4	10	23101
24993	WH_124993	EID_74993	Rural	Mid	South	Zone 3	5	0	2	4591	Rented	33	0	0	1	163	33.0	2000.0	22	0	B+	5	19	26091
24994	WH_124994	EID_74994	Rural	Mid	North	Zone 4	7	0	3	5242	Rented	41	0	0	0	71	25.0	2016.0	9	0	B	1	26	11083
24995	WH_124995	EID_74995	Rural	Small	North	Zone 1	3	0	4	5390	Rented	19	0	0	1	142	34.0	2005.0	22	1	A	2	30	32093
24996	WH_124996	EID_74996	Rural	Mid	West	Zone 2	6	0	4	4490	Company Owned	57	0	0	1	130	28.0	2012.0	10	0	B	4	18	12114
24997	WH_124997	EID_74997	Urban	Large	South	Zone 5	7	0	2	5403	Rented	31	1	0	1	147	NaN	NaN	23	0	B+	5	25	27080
24998	WH_124998	EID_74998	Rural	Small	North	Zone 1	1	0	2	10562	Rented	25	0	0	1	60	25.0	NaN	18	0	A	6	30	25093
24999	WH_124999	EID_74999	Rural	Mid	West	Zone 4	8	2	4	5664	Company Owned	21	0	1	1	239	39.0	2019.0	4	0	B+	2	11	5058

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category